USE [CTEM-DB-v1]
GO
/****** Object:  StoredProcedure [dbo].[Warehouse_Get]    Script Date: 11/17/2011 00:51:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Warehouse_GetByID]
	@ID	NVARCHAR(50)
AS
BEGIN
	SELECT	W.*, C.ConstructionName
	FROM	Warehouse W LEFT OUTER JOIN Construction C ON W.ConstructionID = C.ConstructionID
	WHERE	W.[ConstructionID] = @ID
END
